﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace Core.CurrentFramework.Repository.Migrations
{
    public partial class _202015230 : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "UsersInfo",
                columns: table => new
                {
                    id = table.Column<int>(nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FTeamName = table.Column<string>(maxLength: 50, nullable: false),
                    FUserName = table.Column<string>(maxLength: 50, nullable: false),
                    FUserPwd = table.Column<string>(maxLength: 20, nullable: false),
                    FPic = table.Column<string>(nullable: true),
                    FMobile = table.Column<string>(nullable: true),
                    FEmail = table.Column<string>(nullable: true),
                    FName = table.Column<string>(maxLength: 50, nullable: false),
                    FIdCardNo = table.Column<string>(maxLength: 50, nullable: false),
                    FPayNo = table.Column<string>(nullable: true),
                    Faddress = table.Column<string>(nullable: true),
                    FProjectExperience = table.Column<string>(nullable: true),
                    FStatus = table.Column<bool>(nullable: false),
                    FType = table.Column<int>(nullable: false),
                    FDateTime = table.Column<DateTime>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_UsersInfo", x => x.id);
                });

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 3,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 13, 31, 21, 87, DateTimeKind.Local).AddTicks(5439));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 4,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 13, 31, 21, 89, DateTimeKind.Local).AddTicks(5886));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 5,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 13, 31, 21, 89, DateTimeKind.Local).AddTicks(5967));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 6,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 13, 31, 21, 89, DateTimeKind.Local).AddTicks(5970));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 7,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 13, 31, 21, 89, DateTimeKind.Local).AddTicks(5973));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 8,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 13, 31, 21, 89, DateTimeKind.Local).AddTicks(5975));
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "UsersInfo");

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 3,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 2, 4, 10, 967, DateTimeKind.Local).AddTicks(5470));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 4,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 2, 4, 10, 969, DateTimeKind.Local).AddTicks(5911));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 5,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 2, 4, 10, 969, DateTimeKind.Local).AddTicks(5998));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 6,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 2, 4, 10, 969, DateTimeKind.Local).AddTicks(6001));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 7,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 2, 4, 10, 969, DateTimeKind.Local).AddTicks(6004));

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "id",
                keyValue: 8,
                column: "Birthday",
                value: new DateTime(2020, 3, 21, 2, 4, 10, 969, DateTimeKind.Local).AddTicks(6007));
        }
    }
}
